package com.zhengqing.demo.common;

public class TableConstant {

    public static final String CREATE_TABLE_USER = "CREATE TABLE IF NOT EXISTS `t_user` (\n" +
            "  `user_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n" +
            "  `username` varchar(20) DEFAULT NULL COMMENT '用户名',\n" +
            "  `password` varchar(50) DEFAULT NULL COMMENT '密码',\n" +
            "  `sex` tinyint(4) DEFAULT NULL COMMENT '性别',\n" +
            "  `remark` varchar(100) DEFAULT NULL COMMENT '备注',\n" +
            "  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n" +
            "  PRIMARY KEY (`user_id`) USING BTREE\n" +
            ") ENGINE=InnoDB AUTO_INCREMENT=1630120932104339457 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户'";

}
